package com.financing.wap.common;

/**
 * 
 * @author lisu
 * 
 */
public class SqlName {

	/**
	 * 命名空间分隔符
	 */
	private static final String SEPARATOR = ".";
	
	/**
	 * 添加系统日志
	 */
	final static public String addLogs = "logs.addLog";

	/**
	 * 命名空间：系统公共sql
	 */
	private static final String COMMON_NAMESPACE = "common" + SEPARATOR;

	/**
	 * 查询uuid
	 */
	public static final String QUERY_UUID = COMMON_NAMESPACE + "queryUUID";
	/***
	 *公用sql
	 */
	public class CommonSql {
		//查询每日数据推送用户列表
		public static final String  querySendDataList = COMMON_NAMESPACE + "querySendDataList";
		//热文推送
		public static final String  querySendHotArticleList = COMMON_NAMESPACE + "querySendHotArticleList";
		//查询汇总推送用户列表
		public static final String  sendSummaryReminderList = COMMON_NAMESPACE + "sendSummaryReminderList";
		//实时推送-添加到推送记录表
		public static final String  articleRealTimePush = COMMON_NAMESPACE + "articleRealTimePush";
		//当前用户访问数据
		public static final String  visitDateLog = COMMON_NAMESPACE + "visitDateLog";
		//访问用户最新的访问文章信息
		public static final String  visitArticleInfo = COMMON_NAMESPACE + "visitArticleInfo";
		//访客记录-访客icon
		public static final String  listDstUserVisitLogIcon = COMMON_NAMESPACE + "listDstUserVisitLogIcon";

		//访问列表
		public static final String  dstUserVisitLogList = COMMON_NAMESPACE + "dstUserVisitLogList";
		//访问列表count
		public static final String  dstUserVisitLogListCount = COMMON_NAMESPACE + "dstUserVisitLogListCount";
		//访问-groupDate
		public static final String  dstUserVisitLogGroupDate = COMMON_NAMESPACE + "dstUserVisitLogGroupDate";


		//添加文章访问分享
		public static final String  addVisitArticleLog = COMMON_NAMESPACE + "addVisitArticleLog";
		// 我的所有文章列表
		public static final String  myAllArticleInfo = COMMON_NAMESPACE + "myAllArticleInfo";
		//count
		public static final String  myAllArticleInfoCount = COMMON_NAMESPACE + "myAllArticleInfoCount";


		//admin所有文章列表
		public static final String  adminAllArticleInfo = COMMON_NAMESPACE + "adminAllArticleInfo";
		//count
		public static final String  adminAllArticleInfoCount = COMMON_NAMESPACE + "adminAllArticleInfoCount";
		
		//admin所有文章分类列表
		public static final String  allArticleTypeInfo = COMMON_NAMESPACE + "allArticleTypeInfo";
		//count
		public static final String  allArticleTypeInfoCount = COMMON_NAMESPACE + "allArticleTypeInfoCount";

		//运营统计
		public static final String  queryOperationStatisticsForAll = COMMON_NAMESPACE + "queryOperationStatisticsForAll";
		public static final String  queryOperationStatisticsForDailyDischarge = COMMON_NAMESPACE + "queryOperationStatisticsForDailyDischarge";
		public static final String  queryOperationStatisticsForDailyDischargeUser = COMMON_NAMESPACE + "queryOperationStatisticsForDailyDischargeUser";
		public static final String  queryOperationStatisticsForArticleTrend = COMMON_NAMESPACE + "queryOperationStatisticsForArticleTrend";
		public static final String  queryOperationStatisticsForArticleType = COMMON_NAMESPACE + "queryOperationStatisticsForArticleType";

		//统计访客记录-分享
		public static final String  listDstUserVisitLogShare = COMMON_NAMESPACE + "listDstUserVisitLogShare";
		public static final String  listDstUserVisitLogShareIcon = COMMON_NAMESPACE + "listDstUserVisitLogShareIcon";

		//统计访客记录-周报
		public static final String  addUserWeeklyTypeZh = COMMON_NAMESPACE + "addUserWeeklyTypeZh";
		public static final String  addUserWeeklyTypeView = COMMON_NAMESPACE + "addUserWeeklyTypeView";
		public static final String  addUserWeeklyTypeWz = COMMON_NAMESPACE + "addUserWeeklyTypeWz";

		// admin 客户列表  begin
		public static final String  queryUserInfoListCount = COMMON_NAMESPACE + "queryUserInfoListCount";
		public static final String  queryUserInfoList = COMMON_NAMESPACE + "queryUserInfoList";
		public static final String  queryUserInfoDetailed = COMMON_NAMESPACE + "queryUserInfoDetailed";
		public static final String  adminUserInvitationList = COMMON_NAMESPACE + "adminUserInvitationList";



	}
	
	/***
	 *前台应用公用sql
	 */
	public class CommonDstSql {
		private static final String namespace = "commondst" + SEPARATOR;

		public static final String userInvitationList = namespace + "userInvitationList";
		public static final String shareArticleExecuteUpperLimit = namespace + "shareArticleExecuteUpperLimit";
		public static final String visitExecuteUpperLimit = namespace + "visitExecuteUpperLimit";
		public static final String growthMode = namespace + "growthMode";
		
		public static final String updateMemberInfo = namespace + "updateMemberInfo";
		
		public static final String queryTagByUser = namespace + "queryTagByUser";
		
		public static final String topSearch = namespace + "topSearch";
		
		public static final String visitCountByClientOpenid = namespace + "visitCountByClientOpenid";
		
		public static final String queryArticleForUser = namespace + "queryArticleForUser";

		public static final String dstUserVisitList = namespace + "dstUserVisitList";

		//customerUserVisitLog
		public static final String customerUserVisitLog = namespace + "customerUserVisitLog";
		//cacheUserInfo
		public static final String cacheUserInfo = namespace + "cacheUserInfo";

	}

	// 文章列表
	public class DstArticleSql {

		private static final String namespace = "dstArticle" + SEPARATOR;

		public static final String insert = namespace + "insert";

		public static final String update = namespace + "update";

		public static final String updateForce = namespace + "updateForce";

		public static final String queryList = namespace + "queryList";

		public static final String queryListCount = namespace
				+ "queryListCount";

		public static final String loadById = namespace + "loadById";

		public static final String delete = namespace + "delete";
	}

	// 宣传海报
	public class DstPosterSql {

		private static final String namespace = "dstPoster" + SEPARATOR;

		public static final String insert = namespace + "insert";

		public static final String update = namespace + "update";

		public static final String updateForce = namespace + "updateForce";

		public static final String queryList = namespace + "queryList";

		public static final String queryListCount = namespace
				+ "queryListCount";

		public static final String loadById = namespace + "loadById";

		public static final String delete = namespace + "delete";
	}

	// 用户文章关联
	public class DstUserArticleSql {

		private static final String namespace = "dstUserArticle" + SEPARATOR;

		public static final String insert = namespace + "insert";

		public static final String update = namespace + "update";

		public static final String updateForce = namespace + "updateForce";

		public static final String queryList = namespace + "queryList";

		public static final String queryListCount = namespace
				+ "queryListCount";

		public static final String loadById = namespace + "loadById";

		public static final String delete = namespace + "delete";
	}

	// 用户表
	public class DstUserInfoSql {

		private static final String namespace = "dstUserInfo" + SEPARATOR;

		public static final String insert = namespace + "insert";

		public static final String update = namespace + "update";

		public static final String updateForce = namespace + "updateForce";

		public static final String queryList = namespace + "queryList";

		public static final String queryListCount = namespace
				+ "queryListCount";

		public static final String loadById = namespace + "loadById";

		public static final String delete = namespace + "delete";
	}

	// 用户提醒设置
	public class DstUserSettingSql {

		private static final String namespace = "dstUserSetting" + SEPARATOR;

		public static final String insert = namespace + "insert";

		public static final String update = namespace + "update";

		public static final String updateForce = namespace + "updateForce";

		public static final String queryList = namespace + "queryList";

		public static final String queryListCount = namespace
				+ "queryListCount";

		public static final String loadById = namespace + "loadById";

		public static final String delete = namespace + "delete";
	}

	// 用户访问文章记录
	public class DstUserVisitLogSql {

		private static final String namespace = "dstUserVisitLog" + SEPARATOR;

		public static final String insert = namespace + "insert";

		public static final String update = namespace + "update";

		public static final String updateForce = namespace + "updateForce";

		public static final String queryList = namespace + "queryList";

		public static final String queryListCount = namespace
				+ "queryListCount";

		public static final String loadById = namespace + "loadById";

		public static final String delete = namespace + "delete";
	}

	// 用户访问周报
	public class DstUserWeeklySql {

		private static final String namespace = "dstUserWeekly" + SEPARATOR;

		public static final String insert = namespace + "insert";

		public static final String update = namespace + "update";

		public static final String updateForce = namespace + "updateForce";

		public static final String queryList = namespace + "queryList";

		public static final String queryListCount = namespace
				+ "queryListCount";

		public static final String loadById = namespace + "loadById";

		public static final String delete = namespace + "delete";
	}
	//文章分类
	public class DstArticleCategoriesSql{
		
		private static final String namespace = "dstArticleCategories"+SEPARATOR;
		
		public static final String insert = namespace+"insert";
		
		public static final String update = namespace+"update";
		
		public static final String updateForce = namespace+"updateForce";
		
		public static final String queryList = namespace+"queryList";
		
		public static final String queryListCount = namespace+"queryListCount";
		
		public static final String loadById = namespace+"loadById";
		
		public static final String delete = namespace+"delete";
		
	}
	//用户关联分类和喜爱分类
	public class DstUserArticleCategoriesSql{
			
			private static final String namespace = "dstUserArticleCategories"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String queryAllCategoriesByOpenId = namespace+"queryAllCategoriesByOpenId";
	}
	//用户投诉记录
	public class DstUserComplainSql{
			
			private static final String namespace = "dstUserComplain"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";

			public static final String adminQueryList = namespace+"adminQueryList";
			public static final String adminQueryListCount = namespace+"adminQueryListCount";
	}
	//用户扩展名片信息
	public class DstUserInfoExpandSql{
			
			private static final String namespace = "dstUserInfoExpand"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户微信推送流水 
	public class DstUserWechatSendLogSql{
			
			private static final String namespace = "dstUserWechatSendLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//分享记录
	public class DstArticleShareLogSql{
			
			private static final String namespace = "dstArticleShareLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//文件记录表
	public class DstFileRecordSql{
			
			private static final String namespace = "dstFileRecord"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//文章操作流水
	public class DstOperationLogSql{
			
			private static final String namespace = "dstOperationLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//抓取热文列表
	public class DstNewrankArticleSql{
			
			private static final String namespace = "dstNewrankArticle"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户订阅记录表
	public class DstUserSubscribeLogSql{
			
			private static final String namespace = "dstUserSubscribeLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//积分规则表
	public class DstIntegralRuleSql{
			
			private static final String namespace = "dstIntegralRule"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//会员信息表
	public class DstMemberInfoSql{
			
			private static final String namespace = "dstMemberInfo"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户积分流水表
	public class DstUserIntegralFlowSql{
			
			private static final String namespace = "dstUserIntegralFlow"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//会员开通记录
	public class DstMemberSendLogSql{
			
			private static final String namespace = "dstMemberSendLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户支付流水
	public class DstUserPayLogSql{
			
			private static final String namespace = "dstUserPayLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//虚拟商品表
	public class DstVirtualGoodsSql{
			
			private static final String namespace = "dstVirtualGoods"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//提现积分兑换记录
	public class DstUserWithdrawLogSql{
			
			private static final String namespace = "dstUserWithdrawLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户搜索记录
	public class DstHotSearchLogSql{
			
			private static final String namespace = "dstHotSearchLog"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户标签表
	public class DstUserTagListSql{
			
			private static final String namespace = "dstUserTagList"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户客户标签信息
	public class DstUserClientTagInfoSql{
			
			private static final String namespace = "dstUserClientTagInfo"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//用户客户表
	public class DstUserClientViewSql{
			
			private static final String namespace = "dstUserClientView"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}

	//项目表
	public class PrItemSql{

		private static final String namespace = "prItem"+SEPARATOR;

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}

	//项目发票
	public class PrInvoiceSql{

		private static final String namespace = "prInvoice"+SEPARATOR;

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
	//银行信息
	public class PrBankinfoSql{

		private static final String namespace = "prBankinfo"+SEPARATOR;

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
	//账户银行卡
	public class PrUserBankCardSql{

		private static final String namespace = "prUserBankCard"+SEPARATOR;

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
	//用户认证
	public class PrUserAuthSql{

		private static final String namespace = "prUserAuth"+SEPARATOR;

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
	//
	public class YundaHefeiSql{
			
			private static final String namespace = "yundaHefei"+SEPARATOR;
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
}